package com.cs.beneficios.web.action;
import com.cs.beneficios.business.entity.VflexDAO;
import com.cs.beneficios.business.model.ValorFlexibleVO;
//import com.cs.beneficios.business.model.VflexVO;
import com.cs.beneficios.common.ConnectionFactory;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForward;
//import org.apache.struts.action.ActionError;
//import org.apache.struts.action.ActionErrors;
import java.io.IOException;
import javax.servlet.ServletException;

public class ActivacionBienAction extends Action 
{
  /**
   * This is the main action called from the Struts framework.
   * @param mapping The ActionMapping used to select this instance.
   * @param form The optional ActionForm bean for this request.
   * @param request The HTTP Request we are processing.
   * @param response The HTTP Response we are processing.
   * @return 
   * @throws java.io.IOException
   * @throws javax.servlet.ServletException
   */
  public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
  {
     HttpSession session = request.getSession();
     //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
	 ConnectionFactory cf = new ConnectionFactory();
     
     List lVFL = (List)session.getAttribute("dominioeliminados");
     int tamano = lVFL.size();
     
     for(int i=0;i<tamano;i++)
     {
       VflexDAO tvflDAO = new VflexDAO(cf); 
       ValorFlexibleVO vflex = (ValorFlexibleVO)lVFL.get(i);
       String valor1 = vflex.getCodigovfl();
       String valor2 = request.getParameter(valor1);
       if((Object)valor2 != null)
       {
         try
         {
           int actualizar = tvflDAO.ActValorFlex(valor2);
           cf.closeConnection(tvflDAO.getConn());
           if(actualizar != 0)
           {
             session.setAttribute("msg","El Valor de la lista se activo correctamente");
           }else
           {
              session.setAttribute("msg","El Valor de la lista se activo correctamente");
           }
         }catch(SQLException e)
         {
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSSPE - cwsub ********/");
         }
       }else
       {
         session.setAttribute("msg","No selecciono valores para habilitar");
       }
       
     }
     
   
    return mapping.findForward("success");
  }
}